var user={
	add:"INSERT INTO `tb_book` (`name`,`num`,`book_souce_address`) VALUES (?,?,?)",
	addSeation:"INSERT INTO `tb_book_seation` (`title`, `index`, `book_id`, `text`) VALUES (?, ?, ?,?)",
	getBookList:"select * from tb_book",
	getSectionListById:"select `id`,`title`, `index`, `book_id` , isRead from tb_book_seation where book_id=? order by `index` desc",
	getSectionContextById:"select `text` from tb_book_seation where id=?",
	getMaxSectionById:"select Max(`index`) as maxNo,book_id  from tb_book_seation where book_id=?",
	getBookByName:"select * from tb_book where `name`=?",
	getSectionContext:"select `id` from tb_book_seation where book_id=? and `index`=? ",
	updateSectionState:"update  tb_book_seation set isRead=1 where id =?"

};
module.exports = user;


